﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DotNet.DbUtilities;
using System.Data;

namespace Demo
{
    class Program
    {

        static void Main(string[] args)
        {
            //DotNet.DBUtilities.
            OracleHelper oracleHelper = new OracleHelper();
            oracleHelper.ConnectionString = "Data Source=itr2dev;Persist Security Info=True;User ID=CRDW_REL1;Unicode=True; password=CRDW_ITR2DEV";

            //IDataReader reader = oracleHelper.ExecuteReader("select * from crdw_rel1.cust_d where rownum<10");
 
            //while (reader.Read())
            //{
            //    Console.WriteLine(reader[0].ToString());
            //}

            Console.WriteLine(oracleHelper.ExecuteScalar("select to_char(sysdate, 'fmyyyy/MM/dd,hh:mi:ss') from dual"));
            Console.ReadLine();
        }
    }
}
